linq left join group by

linq left join -

IQueryable&lt;Job&gt; jobs = (from j in _db.Jobs

                join jt in _db.JobTranslators on j.Id equals jt.JobId into jts
                from jtResult in jts.DefaultIfEmpty()

                join jr in _db.JobRevisors on jtResult.Id equals jr.JobId into jrs
                from jrResult in jrs.DefaultIfEmpty()


                join u in _db.Users on jtResult.UserId equals u.Id into jtU
                from jtUResult in jtU.DefaultIfEmpty()

                where jtUResult.Id == userId

                orderby j.Id

                select j).Concat(
                from j in _db.Jobs

                join jt in _db.JobTranslators on j.Id equals jt.JobId into jts
                from jtResult in jts.DefaultIfEmpty()

                join jr in _db.JobRevisors on jtResult.Id equals jr.JobId into jrs
                from jrResult in jrs.DefaultIfEmpty()

                join u in _db.Users on jrResult.UserId equals u.Id into jrU
                from jrUResult in jrU.DefaultIfEmpty()

                where jtUResult.Id == userId

                orderby j.Id

                select j
                ).Distinct()

Comments

Submit

0 Comments

More Questions

url()- full() laravel	how to print in c#	c# how to sort a list
print in c#	get mouse position unity	c# initialize array
string to int c#	Retrieve url path	Generate Random String
string to date vb	modal bootstrap style	abril modal boostrap
c# serialize json	boostrap 4 modal	small modal popup bootstrap
model in bootsrap 4	bootstrap modal popup	c# random string
c sharp split string	string to json c#	laravel get current url
how get url in laravel	how to generate random letters in C#	string to date
laravel route redirect	check if two date ranges overlap c#	Console.WriteLine($Hello Ana.ToUpper($)!);
phone number regex in c#	list min and Max value in c#	check shell command success
attribute c# get method name reflection	c# how to get screen resolution in class	how to make dissapear an object in unity
wpf label text in center	hahhaa i hack u	difference between all logging framework .NET Core
new color unity	c# count files in directory and subdirectories	Hello World Dotnet
import tachyons in react	How can I cast string to enum	.net core add header to soap request
open html file in browser using c++	git find commits by message	c# generate random date
how to get angular on visual studio mac	dotnet core encryption and decryption	asp.net list all files in folder

linq left join group by

linq left join -

Comments

0 Comments

More Questions

C

CSS

Objective-C

PHP

Java

C++

Javascript

Html

Python

SQL

Swift

Ruby

Go

R

TypeScript

Kotlin

Assembly

VBA

Scala

Rust

Elixir

Dart

Haskell

Perl

Fortran

Matlab

Scheme

Julia

Lua

Delphi

Pascal

Solidity

BASIC

ActionScript

Csharp